package com.hzncc.flowable_diboot.mapper;

import com.diboot.core.mapper.BaseCrudMapper;
import com.hzncc.flowable_diboot.entity.BusinessUser;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* Business - User 关联中间表 相关Mapper层接口定义
* @author MyName
* @version 1.0
* @date 2024-06-06
* Copyright © MyCorp
*/
@Mapper
public interface BusinessUserMapper extends BaseCrudMapper<BusinessUser> {

    @Select("select mb.id from mdl_business mb left join mdl_business_iam_user bu on mb.id = bu.business where mb.is_deleted = 0 and bu.is_deleted = 0 and bu.user = #{uid}")
    List<String> selectStar(String uid);
}